

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetCompanyWithStatus0
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    SELECT	COMPANY.COMPANY_NO as 'Company No', 
			COMPANY.COMPANY_NAME as 'Company Name',
			COMPANY.EXPIRATION_FROM as 'Start Date',
			COMPANY.EXPIRATION_TO as 'End Date',
			COMPANY.START_DATE_OF_YEAR as 'Start Date Of Year',
			COMPANY.PAID_TIME_OF_LIMIT as 'Paid Time Of Limit',
			COMPANY.ADDRESS_COM	as 'Address'		
	FROM COMPANY
	WHERE COMPANY.STATUS = 0
END
GO
